package com.blb.mapper;

import com.blb.entity.User;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author PangLei
 * @since 2019-12-23
 */
public interface UserMapper extends BaseMapper<User> {

    @Update("UPDATE t_user SET province=#{province}, city=#{city}, region=#{region} WHERE id=#{id} ")
    void updateaddress(String id ,String province,String city,String region);

    @Update("UPDATE t_user SET nickname=#{nickname} WHERE id=#{id} ")
    void updateNickname(String id,String nickname);

    @Update("UPDATE t_user SET sex=#{sex} WHERE id=#{id} ")
    void updateSex(String id,String sex);

    @Update("UPDATE t_user SET email=#{email} WHERE id=#{id} ")
    void updateEmail(String id,String email);

    @Update("UPDATE t_user SET signature=#{signature} WHERE id=#{id} ")
    void updatesignature(String id,String signature);

}
